select
    r.*,
    s.realName,
    p.alipayNickname alipayNickname,
    IFNULL(t.successQty, 0) successQty
from
	t_stl_sell r
left join t_stl_account s on r.mobile = s.mobile
left join t_pay_account p on r.alipayMobile = p.mobile
left join (
    select buyerMobile, count(1) successQty from t_stl_sell where status = 'Success'
    group by buyerMobile
) t on r.buyerMobile = t.buyerMobile